set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_lmdm_sys_user_role
select
  id
 , user_id
 , role_id
 from jms_ods.yl_lmdm_sys_user_role
where  dt = '{{ execution_date | cst_ds }}';